﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ndDataSet" targetNamespace="http://tempuri.org/ndDataSet.xsd" xmlns:mstns="http://tempuri.org/ndDataSet.xsd" xmlns="http://tempuri.org/ndDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ndConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ndConnectionString (Settings)" PropertyReference="ApplicationSettings.NavDBCreator.Properties.Settings.GlobalReference.Default.ndConnectionString" Provider="System.Data.OleDb" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AirportLookupTableAdapter" GeneratorDataComponentClassName="AirportLookupTableAdapter" Name="AirportLookup" UserDataComponentName="AirportLookupTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ndConnectionString (Settings)" DbObjectName="AirportLookup" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `AirportLookup` WHERE ((`extID` = ?) AND (`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_extID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="extID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `AirportLookup` (`extID`, `ID`) VALUES (?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="extID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="extID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT extID, ID FROM AirportLookup</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `AirportLookup` SET `extID` = ?, `ID` = ? WHERE ((`extID` = ?) AND (`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="extID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="extID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_extID" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="extID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="extID" DataSetColumn="extID" />
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AirportsTableAdapter" GeneratorDataComponentClassName="AirportsTableAdapter" Name="Airports" UserDataComponentName="AirportsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ndConnectionString (Settings)" DbObjectName="Airports" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Airports` WHERE ((`ID` = ?) AND ((? = 1 AND `Name` IS NULL) OR (`Name` = ?)) AND ((? = 1 AND `ICAO` IS NULL) OR (`ICAO` = ?)) AND ((? = 1 AND `PrimaryID` IS NULL) OR (`PrimaryID` = ?)) AND ((? = 1 AND `Latitude` IS NULL) OR (`Latitude` = ?)) AND ((? = 1 AND `Longtitude` IS NULL) OR (`Longtitude` = ?)) AND ((? = 1 AND `Elevation` IS NULL) OR (`Elevation` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ICAO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ICAO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ICAO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ICAO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PrimaryID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PrimaryID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_PrimaryID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PrimaryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Latitude" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_Latitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Longtitude" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_Longtitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Elevation" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Elevation" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_Elevation" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Elevation" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Airports` (`ID`, `Name`, `ICAO`, `PrimaryID`, `Latitude`, `Longtitude`, `Elevation`) VALUES (?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ICAO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ICAO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="PrimaryID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PrimaryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Latitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Longtitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Elevation" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Elevation" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Name, ICAO, PrimaryID, Latitude, Longtitude, Elevation FROM Airports</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Airports` SET `ID` = ?, `Name` = ?, `ICAO` = ?, `PrimaryID` = ?, `Latitude` = ?, `Longtitude` = ?, `Elevation` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `Name` IS NULL) OR (`Name` = ?)) AND ((? = 1 AND `ICAO` IS NULL) OR (`ICAO` = ?)) AND ((? = 1 AND `PrimaryID` IS NULL) OR (`PrimaryID` = ?)) AND ((? = 1 AND `Latitude` IS NULL) OR (`Latitude` = ?)) AND ((? = 1 AND `Longtitude` IS NULL) OR (`Longtitude` = ?)) AND ((? = 1 AND `Elevation` IS NULL) OR (`Elevation` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ICAO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ICAO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="PrimaryID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PrimaryID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Latitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Longtitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Elevation" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Elevation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ICAO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ICAO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ICAO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ICAO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_PrimaryID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PrimaryID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_PrimaryID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="PrimaryID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Latitude" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_Latitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Longtitude" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_Longtitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Elevation" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Elevation" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_Elevation" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Elevation" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="ICAO" DataSetColumn="ICAO" />
              <Mapping SourceColumn="PrimaryID" DataSetColumn="PrimaryID" />
              <Mapping SourceColumn="Latitude" DataSetColumn="Latitude" />
              <Mapping SourceColumn="Longtitude" DataSetColumn="Longtitude" />
              <Mapping SourceColumn="Elevation" DataSetColumn="Elevation" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AirwayLegsTableAdapter" GeneratorDataComponentClassName="AirwayLegsTableAdapter" Name="AirwayLegs" UserDataComponentName="AirwayLegsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ndConnectionString (Settings)" DbObjectName="AirwayLegs" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `AirwayLegs` WHERE ((`ID` = ?) AND ((? = 1 AND `AirwayID` IS NULL) OR (`AirwayID` = ?)) AND ((? = 1 AND `Level` IS NULL) OR (`Level` = ?)) AND ((? = 1 AND `Waypoint1ID` IS NULL) OR (`Waypoint1ID` = ?)) AND ((? = 1 AND `Waypoint2ID` IS NULL) OR (`Waypoint2ID` = ?)) AND ((? = 1 AND `IsStart` IS NULL) OR (`IsStart` = ?)) AND ((? = 1 AND `IsEnd` IS NULL) OR (`IsEnd` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AirwayID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AirwayID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_AirwayID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AirwayID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Level" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Level" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Level" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Level" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Waypoint1ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Waypoint1ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Waypoint1ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Waypoint1ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Waypoint2ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Waypoint2ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Waypoint2ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Waypoint2ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsStart" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsStart" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsStart" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsStart" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsEnd" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsEnd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsEnd" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsEnd" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `AirwayLegs` (`ID`, `AirwayID`, `Level`, `Waypoint1ID`, `Waypoint2ID`, `IsStart`, `IsEnd`) VALUES (?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="AirwayID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AirwayID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Level" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Level" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Waypoint1ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Waypoint1ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Waypoint2ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Waypoint2ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsStart" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsStart" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsEnd" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsEnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, AirwayID, [Level], Waypoint1ID, Waypoint2ID, IsStart, IsEnd FROM AirwayLegs</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `AirwayLegs` SET `ID` = ?, `AirwayID` = ?, `Level` = ?, `Waypoint1ID` = ?, `Waypoint2ID` = ?, `IsStart` = ?, `IsEnd` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `AirwayID` IS NULL) OR (`AirwayID` = ?)) AND ((? = 1 AND `Level` IS NULL) OR (`Level` = ?)) AND ((? = 1 AND `Waypoint1ID` IS NULL) OR (`Waypoint1ID` = ?)) AND ((? = 1 AND `Waypoint2ID` IS NULL) OR (`Waypoint2ID` = ?)) AND ((? = 1 AND `IsStart` IS NULL) OR (`IsStart` = ?)) AND ((? = 1 AND `IsEnd` IS NULL) OR (`IsEnd` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="AirwayID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AirwayID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Level" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Level" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Waypoint1ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Waypoint1ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Waypoint2ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Waypoint2ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsStart" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsStart" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsEnd" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsEnd" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AirwayID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AirwayID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_AirwayID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AirwayID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Level" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Level" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Level" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Level" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Waypoint1ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Waypoint1ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Waypoint1ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Waypoint1ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Waypoint2ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Waypoint2ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Waypoint2ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Waypoint2ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsStart" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsStart" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsStart" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsStart" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsEnd" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsEnd" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsEnd" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsEnd" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="AirwayID" DataSetColumn="AirwayID" />
              <Mapping SourceColumn="Level" DataSetColumn="Level" />
              <Mapping SourceColumn="Waypoint1ID" DataSetColumn="Waypoint1ID" />
              <Mapping SourceColumn="Waypoint2ID" DataSetColumn="Waypoint2ID" />
              <Mapping SourceColumn="IsStart" DataSetColumn="IsStart" />
              <Mapping SourceColumn="IsEnd" DataSetColumn="IsEnd" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AirwaysTableAdapter" GeneratorDataComponentClassName="AirwaysTableAdapter" Name="Airways" UserDataComponentName="AirwaysTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ndConnectionString (Settings)" DbObjectName="Airways" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Airways` WHERE ((`ID` = ?) AND ((? = 1 AND `Ident` IS NULL) OR (`Ident` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Ident" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Airways` (`ID`, `Ident`) VALUES (?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Ident FROM Airways</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Airways` SET `ID` = ?, `Ident` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `Ident` IS NULL) OR (`Ident` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Ident" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Ident" DataSetColumn="Ident" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="configTableAdapter" GeneratorDataComponentClassName="configTableAdapter" Name="config" UserDataComponentName="configTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ndConnectionString (Settings)" DbObjectName="config" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `config` WHERE ((`key` = ?) AND ((? = 1 AND `val` IS NULL) OR (`val` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_key" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="key" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_val" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="val" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_val" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="val" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `config` (`key`, `val`) VALUES (?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="key" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="key" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="val" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="val" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [key], val FROM config</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `config` SET `key` = ?, `val` = ? WHERE ((`key` = ?) AND ((? = 1 AND `val` IS NULL) OR (`val` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="key" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="key" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="val" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="val" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_key" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="key" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_val" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="val" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_val" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="val" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="key" DataSetColumn="key" />
              <Mapping SourceColumn="val" DataSetColumn="val" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ILSesTableAdapter" GeneratorDataComponentClassName="ILSesTableAdapter" Name="ILSes" UserDataComponentName="ILSesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ndConnectionString (Settings)" DbObjectName="ILSes" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `ILSes` WHERE ((`ID` = ?) AND ((? = 1 AND `RunwayID` IS NULL) OR (`RunwayID` = ?)) AND ((? = 1 AND `Freq` IS NULL) OR (`Freq` = ?)) AND ((? = 1 AND `GsAngle` IS NULL) OR (`GsAngle` = ?)) AND ((? = 1 AND `Latitude` IS NULL) OR (`Latitude` = ?)) AND ((? = 1 AND `Longtitude` IS NULL) OR (`Longtitude` = ?)) AND ((? = 1 AND `Category` IS NULL) OR (`Category` = ?)) AND ((? = 1 AND `Ident` IS NULL) OR (`Ident` = ?)) AND ((? = 1 AND `LocCourse` IS NULL) OR (`LocCourse` = ?)) AND ((? = 1 AND `CrossingHeight` IS NULL) OR (`CrossingHeight` = ?)) AND ((? = 1 AND `HasDme` IS NULL) OR (`HasDme` = ?)) AND ((? = 1 AND `Elevation` IS NULL) OR (`Elevation` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_RunwayID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RunwayID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_RunwayID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RunwayID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Freq" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Freq" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Freq" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Freq" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GsAngle" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GsAngle" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_GsAngle" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="GsAngle" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Latitude" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_Latitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Longtitude" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_Longtitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Category" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Category" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_Category" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Category" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Ident" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_LocCourse" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="LocCourse" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_LocCourse" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="LocCourse" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CrossingHeight" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CrossingHeight" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_CrossingHeight" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="CrossingHeight" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_HasDme" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="HasDme" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_HasDme" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="HasDme" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Elevation" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Elevation" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_Elevation" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Elevation" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `ILSes` (`ID`, `RunwayID`, `Freq`, `GsAngle`, `Latitude`, `Longtitude`, `Category`, `Ident`, `LocCourse`, `CrossingHeight`, `HasDme`, `Elevation`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="RunwayID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RunwayID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Freq" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Freq" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="GsAngle" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="GsAngle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Latitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Longtitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Category" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Category" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="LocCourse" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="LocCourse" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="CrossingHeight" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="CrossingHeight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="HasDme" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="HasDme" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Elevation" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Elevation" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, RunwayID, Freq, GsAngle, Latitude, Longtitude, Category, Ident, LocCourse, CrossingHeight, HasDme, Elevation FROM ILSes</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `ILSes` SET `ID` = ?, `RunwayID` = ?, `Freq` = ?, `GsAngle` = ?, `Latitude` = ?, `Longtitude` = ?, `Category` = ?, `Ident` = ?, `LocCourse` = ?, `CrossingHeight` = ?, `HasDme` = ?, `Elevation` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `RunwayID` IS NULL) OR (`RunwayID` = ?)) AND ((? = 1 AND `Freq` IS NULL) OR (`Freq` = ?)) AND ((? = 1 AND `GsAngle` IS NULL) OR (`GsAngle` = ?)) AND ((? = 1 AND `Latitude` IS NULL) OR (`Latitude` = ?)) AND ((? = 1 AND `Longtitude` IS NULL) OR (`Longtitude` = ?)) AND ((? = 1 AND `Category` IS NULL) OR (`Category` = ?)) AND ((? = 1 AND `Ident` IS NULL) OR (`Ident` = ?)) AND ((? = 1 AND `LocCourse` IS NULL) OR (`LocCourse` = ?)) AND ((? = 1 AND `CrossingHeight` IS NULL) OR (`CrossingHeight` = ?)) AND ((? = 1 AND `HasDme` IS NULL) OR (`HasDme` = ?)) AND ((? = 1 AND `Elevation` IS NULL) OR (`Elevation` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="RunwayID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RunwayID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Freq" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Freq" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="GsAngle" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="GsAngle" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Latitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Longtitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Category" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Category" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="LocCourse" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="LocCourse" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="CrossingHeight" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="CrossingHeight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="HasDme" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="HasDme" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Elevation" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Elevation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_RunwayID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RunwayID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_RunwayID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RunwayID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Freq" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Freq" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Freq" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Freq" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_GsAngle" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="GsAngle" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_GsAngle" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="GsAngle" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Latitude" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_Latitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Longtitude" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_Longtitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Category" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Category" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_Category" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Category" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Ident" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_LocCourse" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="LocCourse" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_LocCourse" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="LocCourse" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CrossingHeight" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CrossingHeight" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_CrossingHeight" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="CrossingHeight" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_HasDme" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="HasDme" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_HasDme" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="HasDme" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Elevation" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Elevation" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_Elevation" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Elevation" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="RunwayID" DataSetColumn="RunwayID" />
              <Mapping SourceColumn="Freq" DataSetColumn="Freq" />
              <Mapping SourceColumn="GsAngle" DataSetColumn="GsAngle" />
              <Mapping SourceColumn="Latitude" DataSetColumn="Latitude" />
              <Mapping SourceColumn="Longtitude" DataSetColumn="Longtitude" />
              <Mapping SourceColumn="Category" DataSetColumn="Category" />
              <Mapping SourceColumn="Ident" DataSetColumn="Ident" />
              <Mapping SourceColumn="LocCourse" DataSetColumn="LocCourse" />
              <Mapping SourceColumn="CrossingHeight" DataSetColumn="CrossingHeight" />
              <Mapping SourceColumn="HasDme" DataSetColumn="HasDme" />
              <Mapping SourceColumn="Elevation" DataSetColumn="Elevation" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="NavaidLookupTableAdapter" GeneratorDataComponentClassName="NavaidLookupTableAdapter" Name="NavaidLookup" UserDataComponentName="NavaidLookupTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ndConnectionString (Settings)" DbObjectName="NavaidLookup" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `NavaidLookup` WHERE ((`Ident` = ?) AND (`Type` = ?) AND (`Country` = ?) AND (`NavKeyCode` = ?) AND ((? = 1 AND `ID` IS NULL) OR (`ID` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_Type" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Country" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_NavKeyCode" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="NavKeyCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `NavaidLookup` (`Ident`, `Type`, `Country`, `NavKeyCode`, `ID`) VALUES (?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Type" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Country" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="NavKeyCode" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="NavKeyCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Ident, Type, Country, NavKeyCode, ID FROM NavaidLookup</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `NavaidLookup` SET `Ident` = ?, `Type` = ?, `Country` = ?, `NavKeyCode` = ?, `ID` = ? WHERE ((`Ident` = ?) AND (`Type` = ?) AND (`Country` = ?) AND (`NavKeyCode` = ?) AND ((? = 1 AND `ID` IS NULL) OR (`ID` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Type" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Country" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="NavKeyCode" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="NavKeyCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_Type" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Country" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_NavKeyCode" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="NavKeyCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Ident" DataSetColumn="Ident" />
              <Mapping SourceColumn="Type" DataSetColumn="Type" />
              <Mapping SourceColumn="Country" DataSetColumn="Country" />
              <Mapping SourceColumn="NavKeyCode" DataSetColumn="NavKeyCode" />
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="NavaidsTableAdapter" GeneratorDataComponentClassName="NavaidsTableAdapter" Name="Navaids" UserDataComponentName="NavaidsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ndConnectionString (Settings)" DbObjectName="Navaids" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Navaids` WHERE ((`ID` = ?) AND ((? = 1 AND `Ident` IS NULL) OR (`Ident` = ?)) AND ((? = 1 AND `Type` IS NULL) OR (`Type` = ?)) AND ((? = 1 AND `Name` IS NULL) OR (`Name` = ?)) AND ((? = 1 AND `Freq` IS NULL) OR (`Freq` = ?)) AND ((? = 1 AND `Channel` IS NULL) OR (`Channel` = ?)) AND ((? = 1 AND `Usage` IS NULL) OR (`Usage` = ?)) AND ((? = 1 AND `Latitude` IS NULL) OR (`Latitude` = ?)) AND ((? = 1 AND `Longtitude` IS NULL) OR (`Longtitude` = ?)) AND ((? = 1 AND `Elevation` IS NULL) OR (`Elevation` = ?)) AND ((? = 1 AND `SlavedVar` IS NULL) OR (`SlavedVar` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Ident" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Type" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_Type" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Freq" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Freq" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Freq" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Freq" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Channel" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Channel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Channel" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Channel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Usage" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Usage" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Usage" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Usage" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Latitude" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_Latitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Longtitude" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_Longtitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Elevation" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Elevation" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_Elevation" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Elevation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SlavedVar" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="SlavedVar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_SlavedVar" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="SlavedVar" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Navaids` (`ID`, `Ident`, `Type`, `Name`, `Freq`, `Channel`, `Usage`, `Latitude`, `Longtitude`, `Elevation`, `SlavedVar`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Type" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Freq" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Freq" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Channel" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Channel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Usage" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Usage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Latitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Longtitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Elevation" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Elevation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="SlavedVar" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="SlavedVar" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Ident, Type, Name, Freq, Channel, [Usage], Latitude, Longtitude, Elevation, SlavedVar FROM Navaids</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Navaids` SET `ID` = ?, `Ident` = ?, `Type` = ?, `Name` = ?, `Freq` = ?, `Channel` = ?, `Usage` = ?, `Latitude` = ?, `Longtitude` = ?, `Elevation` = ?, `SlavedVar` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `Ident` IS NULL) OR (`Ident` = ?)) AND ((? = 1 AND `Type` IS NULL) OR (`Type` = ?)) AND ((? = 1 AND `Name` IS NULL) OR (`Name` = ?)) AND ((? = 1 AND `Freq` IS NULL) OR (`Freq` = ?)) AND ((? = 1 AND `Channel` IS NULL) OR (`Channel` = ?)) AND ((? = 1 AND `Usage` IS NULL) OR (`Usage` = ?)) AND ((? = 1 AND `Latitude` IS NULL) OR (`Latitude` = ?)) AND ((? = 1 AND `Longtitude` IS NULL) OR (`Longtitude` = ?)) AND ((? = 1 AND `Elevation` IS NULL) OR (`Elevation` = ?)) AND ((? = 1 AND `SlavedVar` IS NULL) OR (`SlavedVar` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Type" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Freq" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Freq" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Channel" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Channel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Usage" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Usage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Latitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Longtitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Elevation" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Elevation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="SlavedVar" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="SlavedVar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Ident" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Type" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_Type" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Freq" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Freq" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_Freq" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Freq" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Channel" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Channel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Channel" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Channel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Usage" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Usage" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Usage" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Usage" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Latitude" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_Latitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Longtitude" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_Longtitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Elevation" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Elevation" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_Elevation" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Elevation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SlavedVar" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="SlavedVar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_SlavedVar" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="SlavedVar" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Ident" DataSetColumn="Ident" />
              <Mapping SourceColumn="Type" DataSetColumn="Type" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Freq" DataSetColumn="Freq" />
              <Mapping SourceColumn="Channel" DataSetColumn="Channel" />
              <Mapping SourceColumn="Usage" DataSetColumn="Usage" />
              <Mapping SourceColumn="Latitude" DataSetColumn="Latitude" />
              <Mapping SourceColumn="Longtitude" DataSetColumn="Longtitude" />
              <Mapping SourceColumn="Elevation" DataSetColumn="Elevation" />
              <Mapping SourceColumn="SlavedVar" DataSetColumn="SlavedVar" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="NavaidTypesTableAdapter" GeneratorDataComponentClassName="NavaidTypesTableAdapter" Name="NavaidTypes" UserDataComponentName="NavaidTypesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ndConnectionString (Settings)" DbObjectName="NavaidTypes" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `NavaidTypes` WHERE ((`Type` = ?) AND ((? = 1 AND `Desc` IS NULL) OR (`Desc` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_Type" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Desc" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Desc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Desc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Desc" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `NavaidTypes` (`Type`, `Desc`) VALUES (?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Type" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Desc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Desc" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Type, [Desc] FROM NavaidTypes</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `NavaidTypes` SET `Type` = ?, `Desc` = ? WHERE ((`Type` = ?) AND ((? = 1 AND `Desc` IS NULL) OR (`Desc` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Type" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Desc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Desc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_Type" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Desc" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Desc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Desc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Desc" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Type" DataSetColumn="Type" />
              <Mapping SourceColumn="Desc" DataSetColumn="Desc" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RunwaysTableAdapter" GeneratorDataComponentClassName="RunwaysTableAdapter" Name="Runways" UserDataComponentName="RunwaysTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ndConnectionString (Settings)" DbObjectName="Runways" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Runways` WHERE ((`ID` = ?) AND ((? = 1 AND `AirportID` IS NULL) OR (`AirportID` = ?)) AND ((? = 1 AND `Ident` IS NULL) OR (`Ident` = ?)) AND ((? = 1 AND `TrueHeading` IS NULL) OR (`TrueHeading` = ?)) AND ((? = 1 AND `Length` IS NULL) OR (`Length` = ?)) AND ((? = 1 AND `Width` IS NULL) OR (`Width` = ?)) AND ((? = 1 AND `Surface` IS NULL) OR (`Surface` = ?)) AND ((? = 1 AND `Latitude` IS NULL) OR (`Latitude` = ?)) AND ((? = 1 AND `Longtitude` IS NULL) OR (`Longtitude` = ?)) AND ((? = 1 AND `Elevation` IS NULL) OR (`Elevation` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AirportID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AirportID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_AirportID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AirportID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Ident" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TrueHeading" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TrueHeading" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_TrueHeading" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="TrueHeading" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Length" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_Length" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Width" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_Width" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Surface" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Surface" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Surface" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Surface" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Latitude" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_Latitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Longtitude" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_Longtitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Elevation" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Elevation" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_Elevation" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Elevation" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Runways` (`ID`, `AirportID`, `Ident`, `TrueHeading`, `Length`, `Width`, `Surface`, `Latitude`, `Longtitude`, `Elevation`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="AirportID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AirportID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="TrueHeading" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="TrueHeading" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Length" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Width" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Surface" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Surface" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Latitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Longtitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Elevation" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Elevation" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, AirportID, Ident, TrueHeading, Length, Width, Surface, Latitude, Longtitude, Elevation FROM Runways</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Runways` SET `ID` = ?, `AirportID` = ?, `Ident` = ?, `TrueHeading` = ?, `Length` = ?, `Width` = ?, `Surface` = ?, `Latitude` = ?, `Longtitude` = ?, `Elevation` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `AirportID` IS NULL) OR (`AirportID` = ?)) AND ((? = 1 AND `Ident` IS NULL) OR (`Ident` = ?)) AND ((? = 1 AND `TrueHeading` IS NULL) OR (`TrueHeading` = ?)) AND ((? = 1 AND `Length` IS NULL) OR (`Length` = ?)) AND ((? = 1 AND `Width` IS NULL) OR (`Width` = ?)) AND ((? = 1 AND `Surface` IS NULL) OR (`Surface` = ?)) AND ((? = 1 AND `Latitude` IS NULL) OR (`Latitude` = ?)) AND ((? = 1 AND `Longtitude` IS NULL) OR (`Longtitude` = ?)) AND ((? = 1 AND `Elevation` IS NULL) OR (`Elevation` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="AirportID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AirportID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="TrueHeading" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="TrueHeading" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Length" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Width" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Surface" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Surface" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Latitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Longtitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Elevation" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Elevation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AirportID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AirportID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_AirportID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AirportID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Ident" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TrueHeading" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TrueHeading" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_TrueHeading" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="TrueHeading" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Length" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_Length" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Length" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Width" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_Width" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Width" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Surface" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Surface" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Surface" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Surface" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Latitude" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_Latitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Longtitude" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_Longtitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Elevation" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Elevation" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_Elevation" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Elevation" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="AirportID" DataSetColumn="AirportID" />
              <Mapping SourceColumn="Ident" DataSetColumn="Ident" />
              <Mapping SourceColumn="TrueHeading" DataSetColumn="TrueHeading" />
              <Mapping SourceColumn="Length" DataSetColumn="Length" />
              <Mapping SourceColumn="Width" DataSetColumn="Width" />
              <Mapping SourceColumn="Surface" DataSetColumn="Surface" />
              <Mapping SourceColumn="Latitude" DataSetColumn="Latitude" />
              <Mapping SourceColumn="Longtitude" DataSetColumn="Longtitude" />
              <Mapping SourceColumn="Elevation" DataSetColumn="Elevation" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SurfaceTypesTableAdapter" GeneratorDataComponentClassName="SurfaceTypesTableAdapter" Name="SurfaceTypes" UserDataComponentName="SurfaceTypesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ndConnectionString (Settings)" DbObjectName="SurfaceTypes" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `SurfaceTypes` WHERE ((`SurfaceType` = ?) AND ((? = 1 AND `Description` IS NULL) OR (`Description` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_SurfaceType" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="SurfaceType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Description" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Description" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `SurfaceTypes` (`SurfaceType`, `Description`) VALUES (?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="SurfaceType" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="SurfaceType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Description" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT SurfaceType, Description FROM SurfaceTypes</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `SurfaceTypes` SET `SurfaceType` = ?, `Description` = ? WHERE ((`SurfaceType` = ?) AND ((? = 1 AND `Description` IS NULL) OR (`Description` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="SurfaceType" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="SurfaceType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Description" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_SurfaceType" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="SurfaceType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Description" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Description" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SurfaceType" DataSetColumn="SurfaceType" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TerminalLegsTableAdapter" GeneratorDataComponentClassName="TerminalLegsTableAdapter" Name="TerminalLegs" UserDataComponentName="TerminalLegsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ndConnectionString (Settings)" DbObjectName="TerminalLegs" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `TerminalLegs` WHERE ((`ID` = ?) AND ((? = 1 AND `TerminalID` IS NULL) OR (`TerminalID` = ?)) AND ((? = 1 AND `Type` IS NULL) OR (`Type` = ?)) AND ((? = 1 AND `Transition` IS NULL) OR (`Transition` = ?)) AND ((? = 1 AND `TrackCode` IS NULL) OR (`TrackCode` = ?)) AND ((? = 1 AND `WptID` IS NULL) OR (`WptID` = ?)) AND ((? = 1 AND `WptLat` IS NULL) OR (`WptLat` = ?)) AND ((? = 1 AND `WptLon` IS NULL) OR (`WptLon` = ?)) AND ((? = 1 AND `TurnDir` IS NULL) OR (`TurnDir` = ?)) AND ((? = 1 AND `NavID` IS NULL) OR (`NavID` = ?)) AND ((? = 1 AND `NavLat` IS NULL) OR (`NavLat` = ?)) AND ((? = 1 AND `NavLon` IS NULL) OR (`NavLon` = ?)) AND ((? = 1 AND `NavBear` IS NULL) OR (`NavBear` = ?)) AND ((? = 1 AND `NavDist` IS NULL) OR (`NavDist` = ?)) AND ((? = 1 AND `Course` IS NULL) OR (`Course` = ?)) AND ((? = 1 AND `Distance` IS NULL) OR (`Distance` = ?)) AND ((? = 1 AND `Alt` IS NULL) OR (`Alt` = ?)) AND ((? = 1 AND `Vnav` IS NULL) OR (`Vnav` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TerminalID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TerminalID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_TerminalID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TerminalID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Type" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Type" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Transition" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Transition" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Transition" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Transition" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TrackCode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TrackCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_TrackCode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="TrackCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_WptID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="WptID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_WptID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="WptID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_WptLat" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="WptLat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_WptLat" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="WptLat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_WptLon" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="WptLon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_WptLon" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="WptLon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TurnDir" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TurnDir" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_TurnDir" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="TurnDir" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NavID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NavID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_NavID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NavID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NavLat" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NavLat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_NavLat" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="NavLat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NavLon" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NavLon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_NavLon" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="NavLon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NavBear" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NavBear" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_NavBear" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="NavBear" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NavDist" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NavDist" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_NavDist" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="NavDist" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Course" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Course" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_Course" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="Course" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Distance" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Distance" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_Distance" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="Distance" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Alt" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Alt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Alt" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Alt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Vnav" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Vnav" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_Vnav" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="Vnav" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `TerminalLegs` (`ID`, `TerminalID`, `Type`, `Transition`, `TrackCode`, `WptID`, `WptLat`, `WptLon`, `TurnDir`, `NavID`, `NavLat`, `NavLon`, `NavBear`, `NavDist`, `Course`, `Distance`, `Alt`, `Vnav`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="TerminalID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TerminalID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Type" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Transition" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Transition" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="TrackCode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="TrackCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="WptID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="WptID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="WptLat" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="WptLat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="WptLon" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="WptLon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="TurnDir" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="TurnDir" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="NavID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NavID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="NavLat" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="NavLat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="NavLon" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="NavLon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="NavBear" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="NavBear" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="NavDist" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="NavDist" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Course" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="Course" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Distance" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="Distance" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Alt" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Alt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Vnav" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="Vnav" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, TerminalID, Type, Transition, TrackCode, WptID, WptLat, WptLon, TurnDir, NavID, NavLat, NavLon, NavBear, NavDist, Course, Distance, Alt, Vnav FROM TerminalLegs</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `TerminalLegs` SET `ID` = ?, `TerminalID` = ?, `Type` = ?, `Transition` = ?, `TrackCode` = ?, `WptID` = ?, `WptLat` = ?, `WptLon` = ?, `TurnDir` = ?, `NavID` = ?, `NavLat` = ?, `NavLon` = ?, `NavBear` = ?, `NavDist` = ?, `Course` = ?, `Distance` = ?, `Alt` = ?, `Vnav` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `TerminalID` IS NULL) OR (`TerminalID` = ?)) AND ((? = 1 AND `Type` IS NULL) OR (`Type` = ?)) AND ((? = 1 AND `Transition` IS NULL) OR (`Transition` = ?)) AND ((? = 1 AND `TrackCode` IS NULL) OR (`TrackCode` = ?)) AND ((? = 1 AND `WptID` IS NULL) OR (`WptID` = ?)) AND ((? = 1 AND `WptLat` IS NULL) OR (`WptLat` = ?)) AND ((? = 1 AND `WptLon` IS NULL) OR (`WptLon` = ?)) AND ((? = 1 AND `TurnDir` IS NULL) OR (`TurnDir` = ?)) AND ((? = 1 AND `NavID` IS NULL) OR (`NavID` = ?)) AND ((? = 1 AND `NavLat` IS NULL) OR (`NavLat` = ?)) AND ((? = 1 AND `NavLon` IS NULL) OR (`NavLon` = ?)) AND ((? = 1 AND `NavBear` IS NULL) OR (`NavBear` = ?)) AND ((? = 1 AND `NavDist` IS NULL) OR (`NavDist` = ?)) AND ((? = 1 AND `Course` IS NULL) OR (`Course` = ?)) AND ((? = 1 AND `Distance` IS NULL) OR (`Distance` = ?)) AND ((? = 1 AND `Alt` IS NULL) OR (`Alt` = ?)) AND ((? = 1 AND `Vnav` IS NULL) OR (`Vnav` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="TerminalID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TerminalID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Type" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Transition" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Transition" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="TrackCode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="TrackCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="WptID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="WptID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="WptLat" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="WptLat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="WptLon" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="WptLon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="TurnDir" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="TurnDir" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="NavID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NavID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="NavLat" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="NavLat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="NavLon" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="NavLon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="NavBear" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="NavBear" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="NavDist" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="NavDist" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Course" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="Course" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Distance" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="Distance" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Alt" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Alt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Vnav" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="Vnav" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TerminalID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TerminalID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_TerminalID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TerminalID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Type" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Type" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Transition" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Transition" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Transition" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Transition" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TrackCode" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TrackCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_TrackCode" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="TrackCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_WptID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="WptID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_WptID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="WptID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_WptLat" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="WptLat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_WptLat" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="WptLat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_WptLon" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="WptLon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_WptLon" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="WptLon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_TurnDir" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="TurnDir" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_TurnDir" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="TurnDir" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NavID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NavID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_NavID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NavID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NavLat" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NavLat" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_NavLat" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="NavLat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NavLon" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NavLon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_NavLon" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="NavLon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NavBear" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NavBear" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_NavBear" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="NavBear" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NavDist" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NavDist" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_NavDist" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="NavDist" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Course" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Course" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_Course" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="Course" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Distance" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Distance" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_Distance" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="Distance" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Alt" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Alt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Alt" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Alt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Vnav" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Vnav" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_Vnav" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="Vnav" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="TerminalID" DataSetColumn="TerminalID" />
              <Mapping SourceColumn="Type" DataSetColumn="Type" />
              <Mapping SourceColumn="Transition" DataSetColumn="Transition" />
              <Mapping SourceColumn="TrackCode" DataSetColumn="TrackCode" />
              <Mapping SourceColumn="WptID" DataSetColumn="WptID" />
              <Mapping SourceColumn="WptLat" DataSetColumn="WptLat" />
              <Mapping SourceColumn="WptLon" DataSetColumn="WptLon" />
              <Mapping SourceColumn="TurnDir" DataSetColumn="TurnDir" />
              <Mapping SourceColumn="NavID" DataSetColumn="NavID" />
              <Mapping SourceColumn="NavLat" DataSetColumn="NavLat" />
              <Mapping SourceColumn="NavLon" DataSetColumn="NavLon" />
              <Mapping SourceColumn="NavBear" DataSetColumn="NavBear" />
              <Mapping SourceColumn="NavDist" DataSetColumn="NavDist" />
              <Mapping SourceColumn="Course" DataSetColumn="Course" />
              <Mapping SourceColumn="Distance" DataSetColumn="Distance" />
              <Mapping SourceColumn="Alt" DataSetColumn="Alt" />
              <Mapping SourceColumn="Vnav" DataSetColumn="Vnav" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TerminalLegsExTableAdapter" GeneratorDataComponentClassName="TerminalLegsExTableAdapter" Name="TerminalLegsEx" UserDataComponentName="TerminalLegsExTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ndConnectionString (Settings)" DbObjectName="TerminalLegsEx" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `TerminalLegsEx` WHERE ((`ID` = ?) AND ((? = 1 AND `IsFlyOver` IS NULL) OR (`IsFlyOver` = ?)) AND ((? = 1 AND `SpeedLimit` IS NULL) OR (`SpeedLimit` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsFlyOver" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsFlyOver" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsFlyOver" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsFlyOver" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SpeedLimit" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="SpeedLimit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_SpeedLimit" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="SpeedLimit" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `TerminalLegsEx` (`ID`, `IsFlyOver`, `SpeedLimit`) VALUES (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsFlyOver" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsFlyOver" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="SpeedLimit" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="SpeedLimit" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, IsFlyOver, SpeedLimit FROM TerminalLegsEx</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `TerminalLegsEx` SET `ID` = ?, `IsFlyOver` = ?, `SpeedLimit` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `IsFlyOver` IS NULL) OR (`IsFlyOver` = ?)) AND ((? = 1 AND `SpeedLimit` IS NULL) OR (`SpeedLimit` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="IsFlyOver" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsFlyOver" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="SpeedLimit" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="SpeedLimit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_IsFlyOver" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="IsFlyOver" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_IsFlyOver" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="IsFlyOver" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_SpeedLimit" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="SpeedLimit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="Original_SpeedLimit" Precision="0" ProviderType="Single" Scale="0" Size="0" SourceColumn="SpeedLimit" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="IsFlyOver" DataSetColumn="IsFlyOver" />
              <Mapping SourceColumn="SpeedLimit" DataSetColumn="SpeedLimit" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TerminalsTableAdapter" GeneratorDataComponentClassName="TerminalsTableAdapter" Name="Terminals" UserDataComponentName="TerminalsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ndConnectionString (Settings)" DbObjectName="Terminals" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Terminals` WHERE ((`ID` = ?) AND ((? = 1 AND `AirportID` IS NULL) OR (`AirportID` = ?)) AND ((? = 1 AND `Proc` IS NULL) OR (`Proc` = ?)) AND ((? = 1 AND `ICAO` IS NULL) OR (`ICAO` = ?)) AND ((? = 1 AND `FullName` IS NULL) OR (`FullName` = ?)) AND ((? = 1 AND `Name` IS NULL) OR (`Name` = ?)) AND ((? = 1 AND `Rwy` IS NULL) OR (`Rwy` = ?)) AND ((? = 1 AND `RwyID` IS NULL) OR (`RwyID` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AirportID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AirportID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_AirportID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AirportID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Proc" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Proc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_Proc" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Proc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ICAO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ICAO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ICAO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ICAO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FullName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FullName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_FullName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="FullName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Rwy" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Rwy" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Rwy" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Rwy" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_RwyID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RwyID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_RwyID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RwyID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Terminals` (`ID`, `AirportID`, `Proc`, `ICAO`, `FullName`, `Name`, `Rwy`, `RwyID`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="AirportID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AirportID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Proc" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Proc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ICAO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ICAO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="FullName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="FullName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Rwy" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Rwy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="RwyID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RwyID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, AirportID, [Proc], ICAO, FullName, Name, Rwy, RwyID FROM Terminals</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Terminals` SET `ID` = ?, `AirportID` = ?, `Proc` = ?, `ICAO` = ?, `FullName` = ?, `Name` = ?, `Rwy` = ?, `RwyID` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `AirportID` IS NULL) OR (`AirportID` = ?)) AND ((? = 1 AND `Proc` IS NULL) OR (`Proc` = ?)) AND ((? = 1 AND `ICAO` IS NULL) OR (`ICAO` = ?)) AND ((? = 1 AND `FullName` IS NULL) OR (`FullName` = ?)) AND ((? = 1 AND `Name` IS NULL) OR (`Name` = ?)) AND ((? = 1 AND `Rwy` IS NULL) OR (`Rwy` = ?)) AND ((? = 1 AND `RwyID` IS NULL) OR (`RwyID` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="AirportID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AirportID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Proc" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Proc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ICAO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ICAO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="FullName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="FullName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Rwy" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Rwy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="RwyID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RwyID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_AirportID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AirportID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_AirportID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="AirportID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Proc" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Proc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="Original_Proc" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Proc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ICAO" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ICAO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_ICAO" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ICAO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_FullName" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="FullName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_FullName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="FullName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Rwy" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Rwy" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Rwy" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Rwy" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_RwyID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RwyID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_RwyID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="RwyID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="AirportID" DataSetColumn="AirportID" />
              <Mapping SourceColumn="Proc" DataSetColumn="Proc" />
              <Mapping SourceColumn="ICAO" DataSetColumn="ICAO" />
              <Mapping SourceColumn="FullName" DataSetColumn="FullName" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Rwy" DataSetColumn="Rwy" />
              <Mapping SourceColumn="RwyID" DataSetColumn="RwyID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TrmLegTypesTableAdapter" GeneratorDataComponentClassName="TrmLegTypesTableAdapter" Name="TrmLegTypes" UserDataComponentName="TrmLegTypesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ndConnectionString (Settings)" DbObjectName="TrmLegTypes" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `TrmLegTypes` WHERE ((`Code` = ?) AND ((? = 1 AND `Description` IS NULL) OR (`Description` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Description" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Description" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `TrmLegTypes` (`Code`, `Description`) VALUES (?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Description" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Code, Description FROM TrmLegTypes</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `TrmLegTypes` SET `Code` = ?, `Description` = ? WHERE ((`Code` = ?) AND ((? = 1 AND `Description` IS NULL) OR (`Description` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Description" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Code" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Description" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Description" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Code" DataSetColumn="Code" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="WaypointLookupTableAdapter" GeneratorDataComponentClassName="WaypointLookupTableAdapter" Name="WaypointLookup" UserDataComponentName="WaypointLookupTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ndConnectionString (Settings)" DbObjectName="WaypointLookup" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `WaypointLookup` WHERE ((`Ident` = ?) AND (`Country` = ?) AND (`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Country" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `WaypointLookup` (`Ident`, `Country`, `ID`) VALUES (?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Country" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Ident, Country, ID FROM WaypointLookup</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `WaypointLookup` SET `Ident` = ?, `Country` = ?, `ID` = ? WHERE ((`Ident` = ?) AND (`Country` = ?) AND (`ID` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Country" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Country" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Country" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Ident" DataSetColumn="Ident" />
              <Mapping SourceColumn="Country" DataSetColumn="Country" />
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="WaypointsTableAdapter" GeneratorDataComponentClassName="WaypointsTableAdapter" Name="Waypoints" UserDataComponentName="WaypointsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ndConnectionString (Settings)" DbObjectName="Waypoints" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `Waypoints` WHERE ((`ID` = ?) AND ((? = 1 AND `Ident` IS NULL) OR (`Ident` = ?)) AND ((? = 1 AND `Collocated` IS NULL) OR (`Collocated` = ?)) AND ((? = 1 AND `Name` IS NULL) OR (`Name` = ?)) AND ((? = 1 AND `Latitude` IS NULL) OR (`Latitude` = ?)) AND ((? = 1 AND `Longtitude` IS NULL) OR (`Longtitude` = ?)) AND ((? = 1 AND `NavaidID` IS NULL) OR (`NavaidID` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Ident" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Collocated" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Collocated" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_Collocated" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="Collocated" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Latitude" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_Latitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Longtitude" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_Longtitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NavaidID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NavaidID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_NavaidID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NavaidID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `Waypoints` (`ID`, `Ident`, `Collocated`, `Name`, `Latitude`, `Longtitude`, `NavaidID`) VALUES (?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Collocated" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="Collocated" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Latitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Longtitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="NavaidID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NavaidID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Ident, Collocated, Name, Latitude, Longtitude, NavaidID FROM Waypoints</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `Waypoints` SET `ID` = ?, `Ident` = ?, `Collocated` = ?, `Name` = ?, `Latitude` = ?, `Longtitude` = ?, `NavaidID` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `Ident` IS NULL) OR (`Ident` = ?)) AND ((? = 1 AND `Collocated` IS NULL) OR (`Collocated` = ?)) AND ((? = 1 AND `Name` IS NULL) OR (`Name` = ?)) AND ((? = 1 AND `Latitude` IS NULL) OR (`Latitude` = ?)) AND ((? = 1 AND `Longtitude` IS NULL) OR (`Longtitude` = ?)) AND ((? = 1 AND `NavaidID` IS NULL) OR (`NavaidID` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Collocated" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="Collocated" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Latitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Longtitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="NavaidID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NavaidID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Ident" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Ident" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Ident" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Collocated" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Collocated" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_Collocated" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="Collocated" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Latitude" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_Latitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Latitude" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Longtitude" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="Original_Longtitude" Precision="0" ProviderType="Double" Scale="0" Size="0" SourceColumn="Longtitude" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_NavaidID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NavaidID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_NavaidID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="NavaidID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Ident" DataSetColumn="Ident" />
              <Mapping SourceColumn="Collocated" DataSetColumn="Collocated" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Latitude" DataSetColumn="Latitude" />
              <Mapping SourceColumn="Longtitude" DataSetColumn="Longtitude" />
              <Mapping SourceColumn="NavaidID" DataSetColumn="NavaidID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Airports with secondaryTableAdapter" GeneratorDataComponentClassName="Airports_with_secondaryTableAdapter" Name="Airports with secondary" UserDataComponentName="Airports with secondaryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ndConnectionString (Settings)" DbObjectName="Airports with secondary" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Name, ICAO, PrimaryID, Latitude, Longtitude, Elevation FROM [Airports with secondary]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="ICAO" DataSetColumn="ICAO" />
              <Mapping SourceColumn="PrimaryID" DataSetColumn="PrimaryID" />
              <Mapping SourceColumn="Latitude" DataSetColumn="Latitude" />
              <Mapping SourceColumn="Longtitude" DataSetColumn="Longtitude" />
              <Mapping SourceColumn="Elevation" DataSetColumn="Elevation" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DmeChannelsTableAdapter" GeneratorDataComponentClassName="DmeChannelsTableAdapter" Name="DmeChannels" UserDataComponentName="DmeChannelsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ndConnectionString (Settings)" DbObjectName="DmeChannels" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Channel, Freq FROM DmeChannels</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Channel" DataSetColumn="Channel" />
              <Mapping SourceColumn="Freq" DataSetColumn="Freq" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MultipleApproachesTableAdapter" GeneratorDataComponentClassName="MultipleApproachesTableAdapter" Name="MultipleApproaches" UserDataComponentName="MultipleApproachesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ndConnectionString (Settings)" DbObjectName="MultipleApproaches" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ICAO, Name, Rwy, NumIap FROM MultipleApproaches</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ICAO" DataSetColumn="ICAO" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Rwy" DataSetColumn="Rwy" />
              <Mapping SourceColumn="NumIap" DataSetColumn="NumIap" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Secondary AirportsTableAdapter" GeneratorDataComponentClassName="Secondary_AirportsTableAdapter" Name="Secondary Airports" UserDataComponentName="Secondary AirportsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ndConnectionString (Settings)" DbObjectName="Secondary Airports" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Name, ICAO, PrimaryID, Latitude, Longtitude, Elevation FROM [Secondary Airports]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="ICAO" DataSetColumn="ICAO" />
              <Mapping SourceColumn="PrimaryID" DataSetColumn="PrimaryID" />
              <Mapping SourceColumn="Latitude" DataSetColumn="Latitude" />
              <Mapping SourceColumn="Longtitude" DataSetColumn="Longtitude" />
              <Mapping SourceColumn="Elevation" DataSetColumn="Elevation" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources>
          <DbSource ConnectionRef="ndConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="AirportsData" MethodsParameterType="CLR" Modifier="Public" Name="AirportsData" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="AirportsData">
            <SelectCommand>
              <DbCommand CommandType="Text" ModifiedByUser="true">
                <CommandText>SELECT        Airports.ID, Airports.Name, Airports.ICAO, Airports.PrimaryID, Airports.Latitude, Airports.Longtitude, Airports.Elevation, Runways.ID AS Expr1, Runways.AirportID, 
                         Runways.Ident, Runways.TrueHeading, Runways.Length, Runways.Width, Runways.Surface, Runways.Latitude AS Expr2, Runways.Longtitude AS Expr3, 
                         Runways.Elevation AS Expr4, ILSes.ID AS Expr5, ILSes.RunwayID, ILSes.Freq, ILSes.GsAngle, ILSes.Latitude AS Expr6, ILSes.Longtitude AS Expr7, ILSes.Category, 
                         ILSes.Ident AS Expr8, ILSes.LocCourse, ILSes.CrossingHeight, ILSes.HasDme, ILSes.Elevation AS Expr9, Terminals.ID AS Expr10, Terminals.AirportID AS Expr11, 
                         Terminals.[Proc], Terminals.ICAO AS Expr12, Terminals.FullName, Terminals.Name AS Expr13, Terminals.Rwy, Terminals.RwyID
FROM            (((Airports INNER JOIN
                         Runways ON Airports.ID = Runways.ID) INNER JOIN
                         ILSes ON Airports.ID = ILSes.ID) INNER JOIN
                         Terminals ON Airports.ID = Terminals.ID)</CommandText>
                <Parameters />
              </DbCommand>
            </SelectCommand>
          </DbSource>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ndDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="ndDataSet" msprop:Generator_DataSetName="ndDataSet" msprop:EnableTableAdapterManager="True">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="AirportLookup" msprop:Generator_UserTableName="AirportLookup" msprop:Generator_RowDeletedName="AirportLookupRowDeleted" msprop:Generator_RowChangedName="AirportLookupRowChanged" msprop:Generator_RowClassName="AirportLookupRow" msprop:Generator_RowChangingName="AirportLookupRowChanging" msprop:Generator_RowEvArgName="AirportLookupRowChangeEvent" msprop:Generator_RowEvHandlerName="AirportLookupRowChangeEventHandler" msprop:Generator_TableClassName="AirportLookupDataTable" msprop:Generator_TableVarName="tableAirportLookup" msprop:Generator_RowDeletingName="AirportLookupRowDeleting" msprop:Generator_TablePropName="AirportLookup">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="extID" msprop:Generator_UserColumnName="extID" msprop:Generator_ColumnPropNameInRow="extID" msprop:Generator_ColumnVarNameInTable="columnextID" msprop:Generator_ColumnPropNameInTable="extIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="7" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Airports" msprop:Generator_UserTableName="Airports" msprop:Generator_RowDeletedName="AirportsRowDeleted" msprop:Generator_RowChangedName="AirportsRowChanged" msprop:Generator_RowClassName="AirportsRow" msprop:Generator_RowChangingName="AirportsRowChanging" msprop:Generator_RowEvArgName="AirportsRowChangeEvent" msprop:Generator_RowEvHandlerName="AirportsRowChangeEventHandler" msprop:Generator_TableClassName="AirportsDataTable" msprop:Generator_TableVarName="tableAirports" msprop:Generator_RowDeletingName="AirportsRowDeleting" msprop:Generator_TablePropName="Airports">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="38" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ICAO" msprop:Generator_UserColumnName="ICAO" msprop:Generator_ColumnPropNameInRow="ICAO" msprop:Generator_ColumnVarNameInTable="columnICAO" msprop:Generator_ColumnPropNameInTable="ICAOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PrimaryID" msprop:Generator_UserColumnName="PrimaryID" msprop:Generator_ColumnPropNameInRow="PrimaryID" msprop:Generator_ColumnVarNameInTable="columnPrimaryID" msprop:Generator_ColumnPropNameInTable="PrimaryIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Latitude" msprop:Generator_UserColumnName="Latitude" msprop:Generator_ColumnPropNameInRow="Latitude" msprop:Generator_ColumnVarNameInTable="columnLatitude" msprop:Generator_ColumnPropNameInTable="LatitudeColumn" type="xs:double" minOccurs="0" />
              <xs:element name="Longtitude" msprop:Generator_UserColumnName="Longtitude" msprop:Generator_ColumnPropNameInRow="Longtitude" msprop:Generator_ColumnVarNameInTable="columnLongtitude" msprop:Generator_ColumnPropNameInTable="LongtitudeColumn" type="xs:double" minOccurs="0" />
              <xs:element name="Elevation" msprop:Generator_UserColumnName="Elevation" msprop:Generator_ColumnPropNameInRow="Elevation" msprop:Generator_ColumnVarNameInTable="columnElevation" msprop:Generator_ColumnPropNameInTable="ElevationColumn" type="xs:short" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="AirwayLegs" msprop:Generator_UserTableName="AirwayLegs" msprop:Generator_RowDeletedName="AirwayLegsRowDeleted" msprop:Generator_RowChangedName="AirwayLegsRowChanged" msprop:Generator_RowClassName="AirwayLegsRow" msprop:Generator_RowChangingName="AirwayLegsRowChanging" msprop:Generator_RowEvArgName="AirwayLegsRowChangeEvent" msprop:Generator_RowEvHandlerName="AirwayLegsRowChangeEventHandler" msprop:Generator_TableClassName="AirwayLegsDataTable" msprop:Generator_TableVarName="tableAirwayLegs" msprop:Generator_RowDeletingName="AirwayLegsRowDeleting" msprop:Generator_TablePropName="AirwayLegs">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="AirwayID" msprop:Generator_UserColumnName="AirwayID" msprop:Generator_ColumnPropNameInRow="AirwayID" msprop:Generator_ColumnVarNameInTable="columnAirwayID" msprop:Generator_ColumnPropNameInTable="AirwayIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Level" msprop:Generator_UserColumnName="Level" msprop:Generator_ColumnPropNameInRow="Level" msprop:Generator_ColumnVarNameInTable="columnLevel" msprop:Generator_ColumnPropNameInTable="LevelColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Waypoint1ID" msprop:Generator_UserColumnName="Waypoint1ID" msprop:Generator_ColumnPropNameInRow="Waypoint1ID" msprop:Generator_ColumnVarNameInTable="columnWaypoint1ID" msprop:Generator_ColumnPropNameInTable="Waypoint1IDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Waypoint2ID" msprop:Generator_UserColumnName="Waypoint2ID" msprop:Generator_ColumnPropNameInRow="Waypoint2ID" msprop:Generator_ColumnVarNameInTable="columnWaypoint2ID" msprop:Generator_ColumnPropNameInTable="Waypoint2IDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="IsStart" msprop:Generator_UserColumnName="IsStart" msprop:Generator_ColumnPropNameInRow="IsStart" msprop:Generator_ColumnVarNameInTable="columnIsStart" msprop:Generator_ColumnPropNameInTable="IsStartColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="IsEnd" msprop:Generator_UserColumnName="IsEnd" msprop:Generator_ColumnPropNameInRow="IsEnd" msprop:Generator_ColumnVarNameInTable="columnIsEnd" msprop:Generator_ColumnPropNameInTable="IsEndColumn" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Airways" msprop:Generator_UserTableName="Airways" msprop:Generator_RowDeletedName="AirwaysRowDeleted" msprop:Generator_RowChangedName="AirwaysRowChanged" msprop:Generator_RowClassName="AirwaysRow" msprop:Generator_RowChangingName="AirwaysRowChanging" msprop:Generator_RowEvArgName="AirwaysRowChangeEvent" msprop:Generator_RowEvHandlerName="AirwaysRowChangeEventHandler" msprop:Generator_TableClassName="AirwaysDataTable" msprop:Generator_TableVarName="tableAirways" msprop:Generator_RowDeletingName="AirwaysRowDeleting" msprop:Generator_TablePropName="Airways">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="Ident" msprop:Generator_UserColumnName="Ident" msprop:Generator_ColumnPropNameInRow="Ident" msprop:Generator_ColumnVarNameInTable="columnIdent" msprop:Generator_ColumnPropNameInTable="IdentColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="config" msprop:Generator_UserTableName="config" msprop:Generator_RowDeletedName="configRowDeleted" msprop:Generator_RowChangedName="configRowChanged" msprop:Generator_RowClassName="configRow" msprop:Generator_RowChangingName="configRowChanging" msprop:Generator_RowEvArgName="configRowChangeEvent" msprop:Generator_RowEvHandlerName="configRowChangeEventHandler" msprop:Generator_TableClassName="configDataTable" msprop:Generator_TableVarName="tableconfig" msprop:Generator_RowDeletingName="configRowDeleting" msprop:Generator_TablePropName="config">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="key" msprop:Generator_UserColumnName="key" msprop:Generator_ColumnPropNameInRow="key" msprop:Generator_ColumnVarNameInTable="columnkey" msprop:Generator_ColumnPropNameInTable="keyColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="val" msprop:Generator_UserColumnName="val" msprop:Generator_ColumnPropNameInRow="val" msprop:Generator_ColumnVarNameInTable="columnval" msprop:Generator_ColumnPropNameInTable="valColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ILSes" msprop:Generator_UserTableName="ILSes" msprop:Generator_RowDeletedName="ILSesRowDeleted" msprop:Generator_RowChangedName="ILSesRowChanged" msprop:Generator_RowClassName="ILSesRow" msprop:Generator_RowChangingName="ILSesRowChanging" msprop:Generator_RowEvArgName="ILSesRowChangeEvent" msprop:Generator_RowEvHandlerName="ILSesRowChangeEventHandler" msprop:Generator_TableClassName="ILSesDataTable" msprop:Generator_TableVarName="tableILSes" msprop:Generator_RowDeletingName="ILSesRowDeleting" msprop:Generator_TablePropName="ILSes">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="RunwayID" msprop:Generator_UserColumnName="RunwayID" msprop:Generator_ColumnPropNameInRow="RunwayID" msprop:Generator_ColumnVarNameInTable="columnRunwayID" msprop:Generator_ColumnPropNameInTable="RunwayIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Freq" msprop:Generator_UserColumnName="Freq" msprop:Generator_ColumnPropNameInRow="Freq" msprop:Generator_ColumnVarNameInTable="columnFreq" msprop:Generator_ColumnPropNameInTable="FreqColumn" type="xs:int" minOccurs="0" />
              <xs:element name="GsAngle" msprop:Generator_UserColumnName="GsAngle" msprop:Generator_ColumnPropNameInRow="GsAngle" msprop:Generator_ColumnVarNameInTable="columnGsAngle" msprop:Generator_ColumnPropNameInTable="GsAngleColumn" type="xs:float" minOccurs="0" />
              <xs:element name="Latitude" msprop:Generator_UserColumnName="Latitude" msprop:Generator_ColumnPropNameInRow="Latitude" msprop:Generator_ColumnVarNameInTable="columnLatitude" msprop:Generator_ColumnPropNameInTable="LatitudeColumn" type="xs:double" minOccurs="0" />
              <xs:element name="Longtitude" msprop:Generator_UserColumnName="Longtitude" msprop:Generator_ColumnPropNameInRow="Longtitude" msprop:Generator_ColumnVarNameInTable="columnLongtitude" msprop:Generator_ColumnPropNameInTable="LongtitudeColumn" type="xs:double" minOccurs="0" />
              <xs:element name="Category" msprop:Generator_UserColumnName="Category" msprop:Generator_ColumnPropNameInRow="Category" msprop:Generator_ColumnVarNameInTable="columnCategory" msprop:Generator_ColumnPropNameInTable="CategoryColumn" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="Ident" msprop:Generator_UserColumnName="Ident" msprop:Generator_ColumnPropNameInRow="Ident" msprop:Generator_ColumnVarNameInTable="columnIdent" msprop:Generator_ColumnPropNameInTable="IdentColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LocCourse" msprop:Generator_UserColumnName="LocCourse" msprop:Generator_ColumnPropNameInRow="LocCourse" msprop:Generator_ColumnVarNameInTable="columnLocCourse" msprop:Generator_ColumnPropNameInTable="LocCourseColumn" type="xs:float" minOccurs="0" />
              <xs:element name="CrossingHeight" msprop:Generator_UserColumnName="CrossingHeight" msprop:Generator_ColumnPropNameInRow="CrossingHeight" msprop:Generator_ColumnVarNameInTable="columnCrossingHeight" msprop:Generator_ColumnPropNameInTable="CrossingHeightColumn" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="HasDme" msprop:Generator_UserColumnName="HasDme" msprop:Generator_ColumnPropNameInRow="HasDme" msprop:Generator_ColumnVarNameInTable="columnHasDme" msprop:Generator_ColumnPropNameInTable="HasDmeColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="Elevation" msprop:Generator_UserColumnName="Elevation" msprop:Generator_ColumnPropNameInRow="Elevation" msprop:Generator_ColumnVarNameInTable="columnElevation" msprop:Generator_ColumnPropNameInTable="ElevationColumn" type="xs:short" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="NavaidLookup" msprop:Generator_UserTableName="NavaidLookup" msprop:Generator_RowDeletedName="NavaidLookupRowDeleted" msprop:Generator_RowChangedName="NavaidLookupRowChanged" msprop:Generator_RowClassName="NavaidLookupRow" msprop:Generator_RowChangingName="NavaidLookupRowChanging" msprop:Generator_RowEvArgName="NavaidLookupRowChangeEvent" msprop:Generator_RowEvHandlerName="NavaidLookupRowChangeEventHandler" msprop:Generator_TableClassName="NavaidLookupDataTable" msprop:Generator_TableVarName="tableNavaidLookup" msprop:Generator_RowDeletingName="NavaidLookupRowDeleting" msprop:Generator_TablePropName="NavaidLookup">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Ident" msprop:Generator_UserColumnName="Ident" msprop:Generator_ColumnPropNameInRow="Ident" msprop:Generator_ColumnVarNameInTable="columnIdent" msprop:Generator_ColumnPropNameInTable="IdentColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Type" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInTable="TypeColumn" type="xs:unsignedByte" />
              <xs:element name="Country" msprop:Generator_UserColumnName="Country" msprop:Generator_ColumnPropNameInRow="Country" msprop:Generator_ColumnVarNameInTable="columnCountry" msprop:Generator_ColumnPropNameInTable="CountryColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NavKeyCode" msprop:Generator_UserColumnName="NavKeyCode" msprop:Generator_ColumnPropNameInRow="NavKeyCode" msprop:Generator_ColumnVarNameInTable="columnNavKeyCode" msprop:Generator_ColumnPropNameInTable="NavKeyCodeColumn" type="xs:unsignedByte" />
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Navaids" msprop:Generator_UserTableName="Navaids" msprop:Generator_RowDeletedName="NavaidsRowDeleted" msprop:Generator_RowChangedName="NavaidsRowChanged" msprop:Generator_RowClassName="NavaidsRow" msprop:Generator_RowChangingName="NavaidsRowChanging" msprop:Generator_RowEvArgName="NavaidsRowChangeEvent" msprop:Generator_RowEvHandlerName="NavaidsRowChangeEventHandler" msprop:Generator_TableClassName="NavaidsDataTable" msprop:Generator_TableVarName="tableNavaids" msprop:Generator_RowDeletingName="NavaidsRowDeleting" msprop:Generator_TablePropName="Navaids">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="Ident" msprop:Generator_UserColumnName="Ident" msprop:Generator_ColumnPropNameInRow="Ident" msprop:Generator_ColumnVarNameInTable="columnIdent" msprop:Generator_ColumnPropNameInTable="IdentColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Type" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInTable="TypeColumn" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="38" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Freq" msprop:Generator_UserColumnName="Freq" msprop:Generator_ColumnPropNameInRow="Freq" msprop:Generator_ColumnVarNameInTable="columnFreq" msprop:Generator_ColumnPropNameInTable="FreqColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Channel" msprop:Generator_UserColumnName="Channel" msprop:Generator_ColumnPropNameInRow="Channel" msprop:Generator_ColumnVarNameInTable="columnChannel" msprop:Generator_ColumnPropNameInTable="ChannelColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Usage" msprop:Generator_UserColumnName="Usage" msprop:Generator_ColumnPropNameInRow="Usage" msprop:Generator_ColumnVarNameInTable="columnUsage" msprop:Generator_ColumnPropNameInTable="UsageColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Latitude" msprop:Generator_UserColumnName="Latitude" msprop:Generator_ColumnPropNameInRow="Latitude" msprop:Generator_ColumnVarNameInTable="columnLatitude" msprop:Generator_ColumnPropNameInTable="LatitudeColumn" type="xs:double" minOccurs="0" />
              <xs:element name="Longtitude" msprop:Generator_UserColumnName="Longtitude" msprop:Generator_ColumnPropNameInRow="Longtitude" msprop:Generator_ColumnVarNameInTable="columnLongtitude" msprop:Generator_ColumnPropNameInTable="LongtitudeColumn" type="xs:double" minOccurs="0" />
              <xs:element name="Elevation" msprop:Generator_UserColumnName="Elevation" msprop:Generator_ColumnPropNameInRow="Elevation" msprop:Generator_ColumnVarNameInTable="columnElevation" msprop:Generator_ColumnPropNameInTable="ElevationColumn" type="xs:short" minOccurs="0" />
              <xs:element name="SlavedVar" msprop:Generator_UserColumnName="SlavedVar" msprop:Generator_ColumnPropNameInRow="SlavedVar" msprop:Generator_ColumnVarNameInTable="columnSlavedVar" msprop:Generator_ColumnPropNameInTable="SlavedVarColumn" type="xs:float" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="NavaidTypes" msprop:Generator_UserTableName="NavaidTypes" msprop:Generator_RowDeletedName="NavaidTypesRowDeleted" msprop:Generator_RowChangedName="NavaidTypesRowChanged" msprop:Generator_RowClassName="NavaidTypesRow" msprop:Generator_RowChangingName="NavaidTypesRowChanging" msprop:Generator_RowEvArgName="NavaidTypesRowChangeEvent" msprop:Generator_RowEvHandlerName="NavaidTypesRowChangeEventHandler" msprop:Generator_TableClassName="NavaidTypesDataTable" msprop:Generator_TableVarName="tableNavaidTypes" msprop:Generator_RowDeletingName="NavaidTypesRowDeleting" msprop:Generator_TablePropName="NavaidTypes">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Type" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInTable="TypeColumn" type="xs:unsignedByte" />
              <xs:element name="Desc" msprop:Generator_UserColumnName="Desc" msprop:Generator_ColumnPropNameInRow="Desc" msprop:Generator_ColumnVarNameInTable="columnDesc" msprop:Generator_ColumnPropNameInTable="DescColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="24" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Runways" msprop:Generator_UserTableName="Runways" msprop:Generator_RowDeletedName="RunwaysRowDeleted" msprop:Generator_RowChangedName="RunwaysRowChanged" msprop:Generator_RowClassName="RunwaysRow" msprop:Generator_RowChangingName="RunwaysRowChanging" msprop:Generator_RowEvArgName="RunwaysRowChangeEvent" msprop:Generator_RowEvHandlerName="RunwaysRowChangeEventHandler" msprop:Generator_TableClassName="RunwaysDataTable" msprop:Generator_TableVarName="tableRunways" msprop:Generator_RowDeletingName="RunwaysRowDeleting" msprop:Generator_TablePropName="Runways">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="AirportID" msprop:Generator_UserColumnName="AirportID" msprop:Generator_ColumnPropNameInRow="AirportID" msprop:Generator_ColumnVarNameInTable="columnAirportID" msprop:Generator_ColumnPropNameInTable="AirportIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Ident" msprop:Generator_UserColumnName="Ident" msprop:Generator_ColumnPropNameInRow="Ident" msprop:Generator_ColumnVarNameInTable="columnIdent" msprop:Generator_ColumnPropNameInTable="IdentColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TrueHeading" msprop:Generator_UserColumnName="TrueHeading" msprop:Generator_ColumnPropNameInRow="TrueHeading" msprop:Generator_ColumnVarNameInTable="columnTrueHeading" msprop:Generator_ColumnPropNameInTable="TrueHeadingColumn" type="xs:float" minOccurs="0" />
              <xs:element name="Length" msprop:Generator_UserColumnName="Length" msprop:Generator_ColumnPropNameInRow="Length" msprop:Generator_ColumnVarNameInTable="columnLength" msprop:Generator_ColumnPropNameInTable="LengthColumn" type="xs:short" minOccurs="0" />
              <xs:element name="Width" msprop:Generator_UserColumnName="Width" msprop:Generator_ColumnPropNameInRow="Width" msprop:Generator_ColumnVarNameInTable="columnWidth" msprop:Generator_ColumnPropNameInTable="WidthColumn" type="xs:short" minOccurs="0" />
              <xs:element name="Surface" msprop:Generator_UserColumnName="Surface" msprop:Generator_ColumnPropNameInRow="Surface" msprop:Generator_ColumnVarNameInTable="columnSurface" msprop:Generator_ColumnPropNameInTable="SurfaceColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Latitude" msprop:Generator_UserColumnName="Latitude" msprop:Generator_ColumnPropNameInRow="Latitude" msprop:Generator_ColumnVarNameInTable="columnLatitude" msprop:Generator_ColumnPropNameInTable="LatitudeColumn" type="xs:double" minOccurs="0" />
              <xs:element name="Longtitude" msprop:Generator_UserColumnName="Longtitude" msprop:Generator_ColumnPropNameInRow="Longtitude" msprop:Generator_ColumnVarNameInTable="columnLongtitude" msprop:Generator_ColumnPropNameInTable="LongtitudeColumn" type="xs:double" minOccurs="0" />
              <xs:element name="Elevation" msprop:Generator_UserColumnName="Elevation" msprop:Generator_ColumnPropNameInRow="Elevation" msprop:Generator_ColumnVarNameInTable="columnElevation" msprop:Generator_ColumnPropNameInTable="ElevationColumn" type="xs:short" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SurfaceTypes" msprop:Generator_UserTableName="SurfaceTypes" msprop:Generator_RowDeletedName="SurfaceTypesRowDeleted" msprop:Generator_RowChangedName="SurfaceTypesRowChanged" msprop:Generator_RowClassName="SurfaceTypesRow" msprop:Generator_RowChangingName="SurfaceTypesRowChanging" msprop:Generator_RowEvArgName="SurfaceTypesRowChangeEvent" msprop:Generator_RowEvHandlerName="SurfaceTypesRowChangeEventHandler" msprop:Generator_TableClassName="SurfaceTypesDataTable" msprop:Generator_TableVarName="tableSurfaceTypes" msprop:Generator_RowDeletingName="SurfaceTypesRowDeleting" msprop:Generator_TablePropName="SurfaceTypes">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SurfaceType" msprop:Generator_UserColumnName="SurfaceType" msprop:Generator_ColumnPropNameInRow="SurfaceType" msprop:Generator_ColumnVarNameInTable="columnSurfaceType" msprop:Generator_ColumnPropNameInTable="SurfaceTypeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TerminalLegs" msprop:Generator_UserTableName="TerminalLegs" msprop:Generator_RowDeletedName="TerminalLegsRowDeleted" msprop:Generator_RowChangedName="TerminalLegsRowChanged" msprop:Generator_RowClassName="TerminalLegsRow" msprop:Generator_RowChangingName="TerminalLegsRowChanging" msprop:Generator_RowEvArgName="TerminalLegsRowChangeEvent" msprop:Generator_RowEvHandlerName="TerminalLegsRowChangeEventHandler" msprop:Generator_TableClassName="TerminalLegsDataTable" msprop:Generator_TableVarName="tableTerminalLegs" msprop:Generator_RowDeletingName="TerminalLegsRowDeleting" msprop:Generator_TablePropName="TerminalLegs">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="TerminalID" msprop:Generator_UserColumnName="TerminalID" msprop:Generator_ColumnPropNameInRow="TerminalID" msprop:Generator_ColumnVarNameInTable="columnTerminalID" msprop:Generator_ColumnPropNameInTable="TerminalIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Type" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInTable="TypeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Transition" msprop:Generator_UserColumnName="Transition" msprop:Generator_ColumnPropNameInRow="Transition" msprop:Generator_ColumnVarNameInTable="columnTransition" msprop:Generator_ColumnPropNameInTable="TransitionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TrackCode" msprop:Generator_UserColumnName="TrackCode" msprop:Generator_ColumnPropNameInRow="TrackCode" msprop:Generator_ColumnVarNameInTable="columnTrackCode" msprop:Generator_ColumnPropNameInTable="TrackCodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WptID" msprop:Generator_UserColumnName="WptID" msprop:Generator_ColumnPropNameInRow="WptID" msprop:Generator_ColumnVarNameInTable="columnWptID" msprop:Generator_ColumnPropNameInTable="WptIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="WptLat" msprop:Generator_UserColumnName="WptLat" msprop:Generator_ColumnPropNameInRow="WptLat" msprop:Generator_ColumnVarNameInTable="columnWptLat" msprop:Generator_ColumnPropNameInTable="WptLatColumn" type="xs:double" minOccurs="0" />
              <xs:element name="WptLon" msprop:Generator_UserColumnName="WptLon" msprop:Generator_ColumnPropNameInRow="WptLon" msprop:Generator_ColumnVarNameInTable="columnWptLon" msprop:Generator_ColumnPropNameInTable="WptLonColumn" type="xs:double" minOccurs="0" />
              <xs:element name="TurnDir" msprop:Generator_UserColumnName="TurnDir" msprop:Generator_ColumnPropNameInRow="TurnDir" msprop:Generator_ColumnVarNameInTable="columnTurnDir" msprop:Generator_ColumnPropNameInTable="TurnDirColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NavID" msprop:Generator_UserColumnName="NavID" msprop:Generator_ColumnPropNameInRow="NavID" msprop:Generator_ColumnVarNameInTable="columnNavID" msprop:Generator_ColumnPropNameInTable="NavIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="NavLat" msprop:Generator_UserColumnName="NavLat" msprop:Generator_ColumnPropNameInRow="NavLat" msprop:Generator_ColumnVarNameInTable="columnNavLat" msprop:Generator_ColumnPropNameInTable="NavLatColumn" type="xs:double" minOccurs="0" />
              <xs:element name="NavLon" msprop:Generator_UserColumnName="NavLon" msprop:Generator_ColumnPropNameInRow="NavLon" msprop:Generator_ColumnVarNameInTable="columnNavLon" msprop:Generator_ColumnPropNameInTable="NavLonColumn" type="xs:double" minOccurs="0" />
              <xs:element name="NavBear" msprop:Generator_UserColumnName="NavBear" msprop:Generator_ColumnPropNameInRow="NavBear" msprop:Generator_ColumnVarNameInTable="columnNavBear" msprop:Generator_ColumnPropNameInTable="NavBearColumn" type="xs:float" minOccurs="0" />
              <xs:element name="NavDist" msprop:Generator_UserColumnName="NavDist" msprop:Generator_ColumnPropNameInRow="NavDist" msprop:Generator_ColumnVarNameInTable="columnNavDist" msprop:Generator_ColumnPropNameInTable="NavDistColumn" type="xs:float" minOccurs="0" />
              <xs:element name="Course" msprop:Generator_UserColumnName="Course" msprop:Generator_ColumnPropNameInRow="Course" msprop:Generator_ColumnVarNameInTable="columnCourse" msprop:Generator_ColumnPropNameInTable="CourseColumn" type="xs:float" minOccurs="0" />
              <xs:element name="Distance" msprop:Generator_UserColumnName="Distance" msprop:Generator_ColumnPropNameInRow="Distance" msprop:Generator_ColumnVarNameInTable="columnDistance" msprop:Generator_ColumnPropNameInTable="DistanceColumn" type="xs:float" minOccurs="0" />
              <xs:element name="Alt" msprop:Generator_UserColumnName="Alt" msprop:Generator_ColumnPropNameInRow="Alt" msprop:Generator_ColumnVarNameInTable="columnAlt" msprop:Generator_ColumnPropNameInTable="AltColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="12" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Vnav" msprop:Generator_UserColumnName="Vnav" msprop:Generator_ColumnPropNameInRow="Vnav" msprop:Generator_ColumnVarNameInTable="columnVnav" msprop:Generator_ColumnPropNameInTable="VnavColumn" type="xs:float" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TerminalLegsEx" msprop:Generator_UserTableName="TerminalLegsEx" msprop:Generator_RowDeletedName="TerminalLegsExRowDeleted" msprop:Generator_RowChangedName="TerminalLegsExRowChanged" msprop:Generator_RowClassName="TerminalLegsExRow" msprop:Generator_RowChangingName="TerminalLegsExRowChanging" msprop:Generator_RowEvArgName="TerminalLegsExRowChangeEvent" msprop:Generator_RowEvHandlerName="TerminalLegsExRowChangeEventHandler" msprop:Generator_TableClassName="TerminalLegsExDataTable" msprop:Generator_TableVarName="tableTerminalLegsEx" msprop:Generator_RowDeletingName="TerminalLegsExRowDeleting" msprop:Generator_TablePropName="TerminalLegsEx">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="IsFlyOver" msprop:Generator_UserColumnName="IsFlyOver" msprop:Generator_ColumnPropNameInRow="IsFlyOver" msprop:Generator_ColumnVarNameInTable="columnIsFlyOver" msprop:Generator_ColumnPropNameInTable="IsFlyOverColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="SpeedLimit" msprop:Generator_UserColumnName="SpeedLimit" msprop:Generator_ColumnPropNameInRow="SpeedLimit" msprop:Generator_ColumnVarNameInTable="columnSpeedLimit" msprop:Generator_ColumnPropNameInTable="SpeedLimitColumn" type="xs:float" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Terminals" msprop:Generator_UserTableName="Terminals" msprop:Generator_RowDeletedName="TerminalsRowDeleted" msprop:Generator_RowChangedName="TerminalsRowChanged" msprop:Generator_RowClassName="TerminalsRow" msprop:Generator_RowChangingName="TerminalsRowChanging" msprop:Generator_RowEvArgName="TerminalsRowChangeEvent" msprop:Generator_RowEvHandlerName="TerminalsRowChangeEventHandler" msprop:Generator_TableClassName="TerminalsDataTable" msprop:Generator_TableVarName="tableTerminals" msprop:Generator_RowDeletingName="TerminalsRowDeleting" msprop:Generator_TablePropName="Terminals">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="AirportID" msprop:Generator_UserColumnName="AirportID" msprop:Generator_ColumnPropNameInRow="AirportID" msprop:Generator_ColumnVarNameInTable="columnAirportID" msprop:Generator_ColumnPropNameInTable="AirportIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Proc" msprop:Generator_UserColumnName="Proc" msprop:Generator_ColumnPropNameInRow="Proc" msprop:Generator_ColumnVarNameInTable="columnProc" msprop:Generator_ColumnPropNameInTable="ProcColumn" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="ICAO" msprop:Generator_UserColumnName="ICAO" msprop:Generator_ColumnPropNameInRow="ICAO" msprop:Generator_ColumnVarNameInTable="columnICAO" msprop:Generator_ColumnPropNameInTable="ICAOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FullName" msprop:Generator_UserColumnName="FullName" msprop:Generator_ColumnPropNameInRow="FullName" msprop:Generator_ColumnVarNameInTable="columnFullName" msprop:Generator_ColumnPropNameInTable="FullNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="28" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Rwy" msprop:Generator_UserColumnName="Rwy" msprop:Generator_ColumnPropNameInRow="Rwy" msprop:Generator_ColumnVarNameInTable="columnRwy" msprop:Generator_ColumnPropNameInTable="RwyColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RwyID" msprop:Generator_UserColumnName="RwyID" msprop:Generator_ColumnPropNameInRow="RwyID" msprop:Generator_ColumnVarNameInTable="columnRwyID" msprop:Generator_ColumnPropNameInTable="RwyIDColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TrmLegTypes" msprop:Generator_UserTableName="TrmLegTypes" msprop:Generator_RowDeletedName="TrmLegTypesRowDeleted" msprop:Generator_RowChangedName="TrmLegTypesRowChanged" msprop:Generator_RowClassName="TrmLegTypesRow" msprop:Generator_RowChangingName="TrmLegTypesRowChanging" msprop:Generator_RowEvArgName="TrmLegTypesRowChangeEvent" msprop:Generator_RowEvHandlerName="TrmLegTypesRowChangeEventHandler" msprop:Generator_TableClassName="TrmLegTypesDataTable" msprop:Generator_TableVarName="tableTrmLegTypes" msprop:Generator_RowDeletingName="TrmLegTypesRowDeleting" msprop:Generator_TablePropName="TrmLegTypes">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Code" msprop:Generator_UserColumnName="Code" msprop:Generator_ColumnPropNameInRow="Code" msprop:Generator_ColumnVarNameInTable="columnCode" msprop:Generator_ColumnPropNameInTable="CodeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="WaypointLookup" msprop:Generator_UserTableName="WaypointLookup" msprop:Generator_RowDeletedName="WaypointLookupRowDeleted" msprop:Generator_RowChangedName="WaypointLookupRowChanged" msprop:Generator_RowClassName="WaypointLookupRow" msprop:Generator_RowChangingName="WaypointLookupRowChanging" msprop:Generator_RowEvArgName="WaypointLookupRowChangeEvent" msprop:Generator_RowEvHandlerName="WaypointLookupRowChangeEventHandler" msprop:Generator_TableClassName="WaypointLookupDataTable" msprop:Generator_TableVarName="tableWaypointLookup" msprop:Generator_RowDeletingName="WaypointLookupRowDeleting" msprop:Generator_TablePropName="WaypointLookup">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Ident" msprop:Generator_UserColumnName="Ident" msprop:Generator_ColumnPropNameInRow="Ident" msprop:Generator_ColumnVarNameInTable="columnIdent" msprop:Generator_ColumnPropNameInTable="IdentColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Country" msprop:Generator_UserColumnName="Country" msprop:Generator_ColumnPropNameInRow="Country" msprop:Generator_ColumnVarNameInTable="columnCountry" msprop:Generator_ColumnPropNameInTable="CountryColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Waypoints" msprop:Generator_UserTableName="Waypoints" msprop:Generator_RowDeletedName="WaypointsRowDeleted" msprop:Generator_RowChangedName="WaypointsRowChanged" msprop:Generator_RowClassName="WaypointsRow" msprop:Generator_RowChangingName="WaypointsRowChanging" msprop:Generator_RowEvArgName="WaypointsRowChangeEvent" msprop:Generator_RowEvHandlerName="WaypointsRowChangeEventHandler" msprop:Generator_TableClassName="WaypointsDataTable" msprop:Generator_TableVarName="tableWaypoints" msprop:Generator_RowDeletingName="WaypointsRowDeleting" msprop:Generator_TablePropName="Waypoints">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="Ident" msprop:Generator_UserColumnName="Ident" msprop:Generator_ColumnPropNameInRow="Ident" msprop:Generator_ColumnVarNameInTable="columnIdent" msprop:Generator_ColumnPropNameInTable="IdentColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Collocated" msprop:Generator_UserColumnName="Collocated" msprop:Generator_ColumnPropNameInRow="Collocated" msprop:Generator_ColumnVarNameInTable="columnCollocated" msprop:Generator_ColumnPropNameInTable="CollocatedColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Latitude" msprop:Generator_UserColumnName="Latitude" msprop:Generator_ColumnPropNameInRow="Latitude" msprop:Generator_ColumnVarNameInTable="columnLatitude" msprop:Generator_ColumnPropNameInTable="LatitudeColumn" type="xs:double" minOccurs="0" />
              <xs:element name="Longtitude" msprop:Generator_UserColumnName="Longtitude" msprop:Generator_ColumnPropNameInRow="Longtitude" msprop:Generator_ColumnVarNameInTable="columnLongtitude" msprop:Generator_ColumnPropNameInTable="LongtitudeColumn" type="xs:double" minOccurs="0" />
              <xs:element name="NavaidID" msprop:Generator_UserColumnName="NavaidID" msprop:Generator_ColumnPropNameInRow="NavaidID" msprop:Generator_ColumnVarNameInTable="columnNavaidID" msprop:Generator_ColumnPropNameInTable="NavaidIDColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Airports_x0020_with_x0020_secondary" msprop:Generator_UserTableName="Airports with secondary" msprop:Generator_RowDeletedName="Airports_with_secondaryRowDeleted" msprop:Generator_RowChangedName="Airports_with_secondaryRowChanged" msprop:Generator_RowClassName="Airports_with_secondaryRow" msprop:Generator_RowChangingName="Airports_with_secondaryRowChanging" msprop:Generator_RowEvArgName="Airports_with_secondaryRowChangeEvent" msprop:Generator_RowEvHandlerName="Airports_with_secondaryRowChangeEventHandler" msprop:Generator_TableClassName="Airports_with_secondaryDataTable" msprop:Generator_TableVarName="tableAirports_with_secondary" msprop:Generator_RowDeletingName="Airports_with_secondaryRowDeleting" msprop:Generator_TablePropName="Airports_with_secondary">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="38" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ICAO" msprop:Generator_UserColumnName="ICAO" msprop:Generator_ColumnPropNameInRow="ICAO" msprop:Generator_ColumnVarNameInTable="columnICAO" msprop:Generator_ColumnPropNameInTable="ICAOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PrimaryID" msprop:Generator_UserColumnName="PrimaryID" msprop:Generator_ColumnPropNameInRow="PrimaryID" msprop:Generator_ColumnVarNameInTable="columnPrimaryID" msprop:Generator_ColumnPropNameInTable="PrimaryIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Latitude" msprop:Generator_UserColumnName="Latitude" msprop:Generator_ColumnPropNameInRow="Latitude" msprop:Generator_ColumnVarNameInTable="columnLatitude" msprop:Generator_ColumnPropNameInTable="LatitudeColumn" type="xs:double" minOccurs="0" />
              <xs:element name="Longtitude" msprop:Generator_UserColumnName="Longtitude" msprop:Generator_ColumnPropNameInRow="Longtitude" msprop:Generator_ColumnVarNameInTable="columnLongtitude" msprop:Generator_ColumnPropNameInTable="LongtitudeColumn" type="xs:double" minOccurs="0" />
              <xs:element name="Elevation" msprop:Generator_UserColumnName="Elevation" msprop:Generator_ColumnPropNameInRow="Elevation" msprop:Generator_ColumnVarNameInTable="columnElevation" msprop:Generator_ColumnPropNameInTable="ElevationColumn" type="xs:short" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DmeChannels" msprop:Generator_UserTableName="DmeChannels" msprop:Generator_RowDeletedName="DmeChannelsRowDeleted" msprop:Generator_RowChangedName="DmeChannelsRowChanged" msprop:Generator_RowClassName="DmeChannelsRow" msprop:Generator_RowChangingName="DmeChannelsRowChanging" msprop:Generator_RowEvArgName="DmeChannelsRowChangeEvent" msprop:Generator_RowEvHandlerName="DmeChannelsRowChangeEventHandler" msprop:Generator_TableClassName="DmeChannelsDataTable" msprop:Generator_TableVarName="tableDmeChannels" msprop:Generator_RowDeletingName="DmeChannelsRowDeleting" msprop:Generator_TablePropName="DmeChannels">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Channel" msprop:Generator_UserColumnName="Channel" msprop:Generator_ColumnPropNameInRow="Channel" msprop:Generator_ColumnVarNameInTable="columnChannel" msprop:Generator_ColumnPropNameInTable="ChannelColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Freq" msprop:Generator_UserColumnName="Freq" msprop:Generator_ColumnPropNameInRow="Freq" msprop:Generator_ColumnVarNameInTable="columnFreq" msprop:Generator_ColumnPropNameInTable="FreqColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MultipleApproaches" msprop:Generator_UserTableName="MultipleApproaches" msprop:Generator_RowDeletedName="MultipleApproachesRowDeleted" msprop:Generator_RowChangedName="MultipleApproachesRowChanged" msprop:Generator_RowClassName="MultipleApproachesRow" msprop:Generator_RowChangingName="MultipleApproachesRowChanging" msprop:Generator_RowEvArgName="MultipleApproachesRowChangeEvent" msprop:Generator_RowEvHandlerName="MultipleApproachesRowChangeEventHandler" msprop:Generator_TableClassName="MultipleApproachesDataTable" msprop:Generator_TableVarName="tableMultipleApproaches" msprop:Generator_RowDeletingName="MultipleApproachesRowDeleting" msprop:Generator_TablePropName="MultipleApproaches">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ICAO" msprop:Generator_UserColumnName="ICAO" msprop:Generator_ColumnPropNameInRow="ICAO" msprop:Generator_ColumnVarNameInTable="columnICAO" msprop:Generator_ColumnPropNameInTable="ICAOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Rwy" msprop:Generator_UserColumnName="Rwy" msprop:Generator_ColumnPropNameInRow="Rwy" msprop:Generator_ColumnVarNameInTable="columnRwy" msprop:Generator_ColumnPropNameInTable="RwyColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NumIap" msprop:Generator_UserColumnName="NumIap" msprop:Generator_ColumnPropNameInRow="NumIap" msprop:Generator_ColumnVarNameInTable="columnNumIap" msprop:Generator_ColumnPropNameInTable="NumIapColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Secondary_x0020_Airports" msprop:Generator_UserTableName="Secondary Airports" msprop:Generator_RowDeletedName="Secondary_AirportsRowDeleted" msprop:Generator_RowChangedName="Secondary_AirportsRowChanged" msprop:Generator_RowClassName="Secondary_AirportsRow" msprop:Generator_RowChangingName="Secondary_AirportsRowChanging" msprop:Generator_RowEvArgName="Secondary_AirportsRowChangeEvent" msprop:Generator_RowEvHandlerName="Secondary_AirportsRowChangeEventHandler" msprop:Generator_TableClassName="Secondary_AirportsDataTable" msprop:Generator_TableVarName="tableSecondary_Airports" msprop:Generator_RowDeletingName="Secondary_AirportsRowDeleting" msprop:Generator_TablePropName="Secondary_Airports">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="38" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ICAO" msprop:Generator_UserColumnName="ICAO" msprop:Generator_ColumnPropNameInRow="ICAO" msprop:Generator_ColumnVarNameInTable="columnICAO" msprop:Generator_ColumnPropNameInTable="ICAOColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PrimaryID" msprop:Generator_UserColumnName="PrimaryID" msprop:Generator_ColumnPropNameInRow="PrimaryID" msprop:Generator_ColumnVarNameInTable="columnPrimaryID" msprop:Generator_ColumnPropNameInTable="PrimaryIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Latitude" msprop:Generator_UserColumnName="Latitude" msprop:Generator_ColumnPropNameInRow="Latitude" msprop:Generator_ColumnVarNameInTable="columnLatitude" msprop:Generator_ColumnPropNameInTable="LatitudeColumn" type="xs:double" minOccurs="0" />
              <xs:element name="Longtitude" msprop:Generator_UserColumnName="Longtitude" msprop:Generator_ColumnPropNameInRow="Longtitude" msprop:Generator_ColumnVarNameInTable="columnLongtitude" msprop:Generator_ColumnPropNameInTable="LongtitudeColumn" type="xs:double" minOccurs="0" />
              <xs:element name="Elevation" msprop:Generator_UserColumnName="Elevation" msprop:Generator_ColumnPropNameInRow="Elevation" msprop:Generator_ColumnVarNameInTable="columnElevation" msprop:Generator_ColumnPropNameInTable="ElevationColumn" type="xs:short" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:AirportLookup" />
      <xs:field xpath="mstns:extID" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Airports_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Airports" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="AirwayLegs_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:AirwayLegs" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Airways_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Airways" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="config_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:config" />
      <xs:field xpath="mstns:key" />
    </xs:unique>
    <xs:unique name="ILSes_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ILSes" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="NavaidLookup_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:NavaidLookup" />
      <xs:field xpath="mstns:Ident" />
      <xs:field xpath="mstns:Type" />
      <xs:field xpath="mstns:Country" />
      <xs:field xpath="mstns:NavKeyCode" />
    </xs:unique>
    <xs:unique name="Navaids_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Navaids" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="NavaidTypes_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:NavaidTypes" />
      <xs:field xpath="mstns:Type" />
    </xs:unique>
    <xs:unique name="Runways_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Runways" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="SurfaceTypes_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SurfaceTypes" />
      <xs:field xpath="mstns:SurfaceType" />
    </xs:unique>
    <xs:unique name="TerminalLegs_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TerminalLegs" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="TerminalLegsEx_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TerminalLegsEx" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Terminals_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Terminals" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="TrmLegTypes_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TrmLegTypes" />
      <xs:field xpath="mstns:Code" />
    </xs:unique>
    <xs:unique name="WaypointLookup_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:WaypointLookup" />
      <xs:field xpath="mstns:Ident" />
      <xs:field xpath="mstns:Country" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Waypoints_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Waypoints" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Airports_x0020_with_x0020_secondary_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Airports_x0020_with_x0020_secondary" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Secondary_x0020_Airports_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Secondary_x0020_Airports" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="AirportAirportLookup" msdata:parent="Airports" msdata:child="AirportLookup" msdata:parentkey="ID" msdata:childkey="ID" msprop:Generator_UserRelationName="AirportAirportLookup" msprop:Generator_RelationVarName="relationAirportAirportLookup" msprop:Generator_UserChildTable="AirportLookup" msprop:Generator_UserParentTable="Airports" msprop:Generator_ParentPropName="AirportsRow" msprop:Generator_ChildPropName="GetAirportLookupRows" />
      <msdata:Relationship name="AirportsAirports" msdata:parent="Airports" msdata:child="Airports" msdata:parentkey="ID" msdata:childkey="PrimaryID" msprop:Generator_UserRelationName="AirportsAirports" msprop:Generator_RelationVarName="relationAirportsAirports" msprop:Generator_UserChildTable="Airports" msprop:Generator_UserParentTable="Airports" msprop:Generator_ParentPropName="AirportsRowParent" msprop:Generator_ChildPropName="GetAirportsRows" />
      <msdata:Relationship name="AirwaysAirwayLegs" msdata:parent="Airways" msdata:child="AirwayLegs" msdata:parentkey="ID" msdata:childkey="AirwayID" msprop:Generator_UserRelationName="AirwaysAirwayLegs" msprop:Generator_RelationVarName="relationAirwaysAirwayLegs" msprop:Generator_UserChildTable="AirwayLegs" msprop:Generator_UserParentTable="Airways" msprop:Generator_ParentPropName="AirwaysRow" msprop:Generator_ChildPropName="GetAirwayLegsRows" />
      <msdata:Relationship name="WaypointsAirwayLegs" msdata:parent="Waypoints" msdata:child="AirwayLegs" msdata:parentkey="ID" msdata:childkey="Waypoint1ID" msprop:Generator_UserRelationName="WaypointsAirwayLegs" msprop:Generator_RelationVarName="relationWaypointsAirwayLegs" msprop:Generator_UserChildTable="AirwayLegs" msprop:Generator_UserParentTable="Waypoints" msprop:Generator_ParentPropName="WaypointsRowByWaypointsAirwayLegs" msprop:Generator_ChildPropName="GetAirwayLegsRowsByWaypointsAirwayLegs" />
      <msdata:Relationship name="WaypointsAirwayLegs1" msdata:parent="Waypoints" msdata:child="AirwayLegs" msdata:parentkey="ID" msdata:childkey="Waypoint2ID" msprop:Generator_UserRelationName="WaypointsAirwayLegs1" msprop:Generator_RelationVarName="relationWaypointsAirwayLegs1" msprop:Generator_UserChildTable="AirwayLegs" msprop:Generator_UserParentTable="Waypoints" msprop:Generator_ParentPropName="WaypointsRowByWaypointsAirwayLegs1" msprop:Generator_ChildPropName="GetAirwayLegsRowsByWaypointsAirwayLegs1" />
      <msdata:Relationship name="RunwaysILSes" msdata:parent="Runways" msdata:child="ILSes" msdata:parentkey="ID" msdata:childkey="RunwayID" msprop:Generator_UserRelationName="RunwaysILSes" msprop:Generator_RelationVarName="relationRunwaysILSes" msprop:Generator_UserChildTable="ILSes" msprop:Generator_UserParentTable="Runways" msprop:Generator_ParentPropName="RunwaysRow" msprop:Generator_ChildPropName="GetILSesRows" />
      <msdata:Relationship name="NavaidsNavaidsLookup" msdata:parent="Navaids" msdata:child="NavaidLookup" msdata:parentkey="ID" msdata:childkey="ID" msprop:Generator_UserRelationName="NavaidsNavaidsLookup" msprop:Generator_RelationVarName="relationNavaidsNavaidsLookup" msprop:Generator_UserChildTable="NavaidLookup" msprop:Generator_UserParentTable="Navaids" msprop:Generator_ParentPropName="NavaidsRow" msprop:Generator_ChildPropName="GetNavaidLookupRows" />
      <msdata:Relationship name="NavaidTypesNavaids" msdata:parent="NavaidTypes" msdata:child="Navaids" msdata:parentkey="Type" msdata:childkey="Type" msprop:Generator_UserRelationName="NavaidTypesNavaids" msprop:Generator_RelationVarName="relationNavaidTypesNavaids" msprop:Generator_UserChildTable="Navaids" msprop:Generator_UserParentTable="NavaidTypes" msprop:Generator_ParentPropName="NavaidTypesRow" msprop:Generator_ChildPropName="GetNavaidsRows" />
      <msdata:Relationship name="AirportsRunways" msdata:parent="Airports" msdata:child="Runways" msdata:parentkey="ID" msdata:childkey="AirportID" msprop:Generator_UserRelationName="AirportsRunways" msprop:Generator_RelationVarName="relationAirportsRunways" msprop:Generator_UserChildTable="Runways" msprop:Generator_UserParentTable="Airports" msprop:Generator_ParentPropName="AirportsRow" msprop:Generator_ChildPropName="GetRunwaysRows" />
      <msdata:Relationship name="SurfaceTypesRunways" msdata:parent="SurfaceTypes" msdata:child="Runways" msdata:parentkey="SurfaceType" msdata:childkey="Surface" msprop:Generator_UserRelationName="SurfaceTypesRunways" msprop:Generator_RelationVarName="relationSurfaceTypesRunways" msprop:Generator_UserChildTable="Runways" msprop:Generator_UserParentTable="SurfaceTypes" msprop:Generator_ParentPropName="SurfaceTypesRow" msprop:Generator_ChildPropName="GetRunwaysRows" />
      <msdata:Relationship name="NavaidsTerminalLegs" msdata:parent="Navaids" msdata:child="TerminalLegs" msdata:parentkey="ID" msdata:childkey="NavID" msprop:Generator_UserRelationName="NavaidsTerminalLegs" msprop:Generator_RelationVarName="relationNavaidsTerminalLegs" msprop:Generator_UserChildTable="TerminalLegs" msprop:Generator_UserParentTable="Navaids" msprop:Generator_ParentPropName="NavaidsRow" msprop:Generator_ChildPropName="GetTerminalLegsRows" />
      <msdata:Relationship name="TerminalLegsExTerminalLegs" msdata:parent="TerminalLegsEx" msdata:child="TerminalLegs" msdata:parentkey="ID" msdata:childkey="ID" msprop:Generator_UserRelationName="TerminalLegsExTerminalLegs" msprop:Generator_RelationVarName="relationTerminalLegsExTerminalLegs" msprop:Generator_UserChildTable="TerminalLegs" msprop:Generator_UserParentTable="TerminalLegsEx" msprop:Generator_ParentPropName="TerminalLegsExRow" msprop:Generator_ChildPropName="GetTerminalLegsRows" />
      <msdata:Relationship name="TerminalsTerminalLegs" msdata:parent="Terminals" msdata:child="TerminalLegs" msdata:parentkey="ID" msdata:childkey="TerminalID" msprop:Generator_UserRelationName="TerminalsTerminalLegs" msprop:Generator_RelationVarName="relationTerminalsTerminalLegs" msprop:Generator_UserChildTable="TerminalLegs" msprop:Generator_UserParentTable="Terminals" msprop:Generator_ParentPropName="TerminalsRow" msprop:Generator_ChildPropName="GetTerminalLegsRows" />
      <msdata:Relationship name="TrmLegTypesTerminalLegs" msdata:parent="TrmLegTypes" msdata:child="TerminalLegs" msdata:parentkey="Code" msdata:childkey="TrackCode" msprop:Generator_UserRelationName="TrmLegTypesTerminalLegs" msprop:Generator_RelationVarName="relationTrmLegTypesTerminalLegs" msprop:Generator_UserChildTable="TerminalLegs" msprop:Generator_UserParentTable="TrmLegTypes" msprop:Generator_ParentPropName="TrmLegTypesRow" msprop:Generator_ChildPropName="GetTerminalLegsRows" />
      <msdata:Relationship name="WaypointsTerminalLegs" msdata:parent="Waypoints" msdata:child="TerminalLegs" msdata:parentkey="ID" msdata:childkey="WptID" msprop:Generator_UserRelationName="WaypointsTerminalLegs" msprop:Generator_RelationVarName="relationWaypointsTerminalLegs" msprop:Generator_UserChildTable="TerminalLegs" msprop:Generator_UserParentTable="Waypoints" msprop:Generator_ParentPropName="WaypointsRow" msprop:Generator_ChildPropName="GetTerminalLegsRows" />
      <msdata:Relationship name="AirportsTerminals" msdata:parent="Airports" msdata:child="Terminals" msdata:parentkey="ID" msdata:childkey="AirportID" msprop:Generator_UserRelationName="AirportsTerminals" msprop:Generator_RelationVarName="relationAirportsTerminals" msprop:Generator_UserChildTable="Terminals" msprop:Generator_UserParentTable="Airports" msprop:Generator_ParentPropName="AirportsRow" msprop:Generator_ChildPropName="GetTerminalsRows" />
      <msdata:Relationship name="WaypointsWaypointsLookup" msdata:parent="Waypoints" msdata:child="WaypointLookup" msdata:parentkey="ID" msdata:childkey="ID" msprop:Generator_UserRelationName="WaypointsWaypointsLookup" msprop:Generator_RelationVarName="relationWaypointsWaypointsLookup" msprop:Generator_UserChildTable="WaypointLookup" msprop:Generator_UserParentTable="Waypoints" msprop:Generator_ParentPropName="WaypointsRow" msprop:Generator_ChildPropName="GetWaypointLookupRows" />
      <msdata:Relationship name="NavaidsWaypoints" msdata:parent="Navaids" msdata:child="Waypoints" msdata:parentkey="ID" msdata:childkey="NavaidID" msprop:Generator_UserRelationName="NavaidsWaypoints" msprop:Generator_RelationVarName="relationNavaidsWaypoints" msprop:Generator_UserChildTable="Waypoints" msprop:Generator_UserParentTable="Navaids" msprop:Generator_ParentPropName="NavaidsRow" msprop:Generator_ChildPropName="GetWaypointsRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>